Welcome to our first ever course Excel functions to analyze and visualize data We are glad to meet you. If only we could shake hands! Are you wondering how is this course going to be useful to you? Hey, did you watch the promo video? If not, please do. If you are looking to learn Microsoft Excel basics, this course will teach you exactly that. Look, Microsoft Excel is ubiquitous. It is used in almost every job we do in today's world. So your job will also possibly require you to do analysis on large heaps of data. Our course does exactly that - we make you job ready for your prospective project / daily work. What makes our course different from others? Our course content is unique - you learn exactly what you are required to do in your daily work. You get 1.5 hours of crisp synthesized practical real life illustrations of all concepts. You will be carrying out the real life illustrations along with the instructor. Same set up as the instructor. All illustration spreadsheets are shared. It's almost like as if somebody is guiding you in person to carry out the various analysis. You are going to love our instructor's teaching style. He makes it very engaging and fun learning experience. You will have practice assignments / course challenges with varying difficulty levels to test your learning from the course. Our support team responds to any course queries within 24 hours of your request. And of course, the price is competitive. What will you learn in this course? An overview of Microsoft Excel functions (Large) Data Analysis techniques and Data visualization in Excel This one single course will be comprehensive to cover the basic knowledge of Excel required for day to day work You can watch the FREE course previews in the CURRICULUM section. Read through the entire CURRICULUM section if you can. All modules with details of lectures are provided. What  next? Well, we sincerely hope to see you inside the course. We wish you well and good luck. Still confused? Don't hesitate to reach out.

Excel Formulas can seem daunting and even scary at first. In this course Excel formulas are made easy as you learn all the essential skills to writing formulas. Master Excel Formulas Easily with this Comprehensive Course Understand Excel formulas inside out. Learn over 60 different Excel functions. Write complex formulas with ease. Recognise formula errors and fix common problems. Hear What Some of our Students have Been Saying "Great instructor and excellent way of explaining." "Brilliant course! Finally a course that leaves you understanding everything without needing to review a dozen times. I have reviewed and learned much more from this easy to follow course due to the step by step tutorials and its clear, engaging delivery by an excellent and knowledgeable instructor. It has helped me understand more formulas in excel that can help me with my business. Many thanks to all involved and keep up the great work." "straight to the point, clear explanation and demo, use common sense language to interpret the formula, and simple and easy illustrative example." Learn Everything You Need to Write Formulas with Ease . Formulas are what drive Excel. They are the muscles allowing users to manipulate, lookup, aggregate and test data with ease. Learning how to write formulas is an important skill for any Excel user looking to develop their talents. Content and Overview This course was designed for anybody who needs to be able to confidently work with formulas in Excel. It is suitable both for complete beginners who want to start from the basics, and for those that have some experience but want to take things further. The course is broken into different sections. It starts with building an understanding of the different elements of a formula, what the various symbols mean, some basic functions and different techniques for referencing cells. Each section then focuses on a specific function category such as date or lookup functions. It starts to take things further by tackling mini projects and looking at more advanced formulas. In over 80 lectures this course will teach you all the necessary skills to write advanced formulas with ease, and make those formula demons a thing of the past. Working files are provided so that you can follow along and practice. You can also get assistance from myself with any queries you may have.

This course is focused on transforming students into Excel Wizards to give them a distinct competitive advantage over their peers. It is centered on teaching students how to master the art and science of problem solving with formulas in Excel. The course takes a unique approach that is rooted in solving real world problems . This gives students an apprenticeship experience as opposed to a traditional lecture approach. By the end of the course, students will have worked nearly 170 examples and will have learned how to leverage Excel to solve just about any problem they might face in practice. Students will cover just under 100 functions in the course and will be proficient in reading and writing even the most complex formulas in Excel. The course is broken down into two modules. The first module provides an introduction to Excel. This module is intended to get everyone on the same page, so even those who have never used Excel can feel comfortable starting with this course . The second module teaches students how to become formula masters and expert problem solvers with Excel. This module is broken down into seven sections that are mapped to functional areas, once again putting an emphasis on how Excel is used in the real world. This course offers students: Over 16 hours of valuable video instruction that is uniquely structured to share the lessons learned from over a decade of professional experience Over 125 quiz questions strategically placed throughout the course to help test your understanding and reinforce what you’ve learned A Practical Application Workbook and solution manual for each section An Excel Wizard’s Guide to Critical Skills A Comprehensive Data Aggregation Reference Sheet This course is intended for individuals who have a desire to become phenomenal at writing formulas in Excel. This includes: Recent or soon to be college graduates Individuals who work in analyst, consulting, management, or supervisory roles Individuals looking to gain a tangible skill on their resume Individuals looking to gain a competitive advantage over their peers Recent studies show it pays to know Excel. Get started today!

One of the world’s leading consulting firms, the McKinsey Global Institute, has identified a huge gap between the demand for people with deep analytical skills, and the supply of qualified candidates. They call it a “critical shortage”, totaling more than 150,000 people by 2018. They’re not only talking about careers in computer programming. They’re saying that these skills will be required for almost all middle-class careers, from HR to sales, accounting to purchasing, and even factory production workers. Where do you start, to improve your analytical skills and increase your opportunities for a good career? Start by learning Excel. Excel is the primary analytical tool used in business today. How do I know? I’m a senior business executive, with over 25 years of experience across several different industries. Excel is the perfect foundation on which to build your analytical skills. There are many Excel courses – why take one of mine? Because I’m a business executive, I know how Excel is used in business. I know the analytical skills needed. And don’t just take my word for it. Here's more proof A local university uses my Udemy courses to teach pivot tables. And my courses are recommended by the Oregon Business Education Association. What do they like about my courses? They like the realistic case studies. One case study is followed throughout the entire course, showing how business uses Excel to solve real-world problems. Students learn about Excel more deeply, and the knowledge “sticks”, because the course is more than just a list of commands and menu paths. The course is based on a real business problem that you solve during the course. This course covers these topics in Excel: Importing Text Files Date Functions Text Functions Logical Functions (IF, OR, AND) The VLOOKUP function, to make cross-reference tables Table Functions, including pivot tables and pivot charts Learn and master more than 47 Excel functions The course is targeted at people who have some familiarity with Excel. You should know how to edit data, create formulas, and use the copy / paste functions, like Control-C and Control-V. Content and Overview There are 27 lessons, comprising about 2 hours of video. The course is based on a case study, to evaluate the performance of two service companies. Each company has sent a text file with their repair history, thousands of records each. The data is dirty: there are duplicate records, the dates are encoded in text fields,and the product codes are not harmonized. Just like real life. Students will learn how to use Excel functions to import the data and clean up the files. Most lessons have a practice session. I provide two Excel files: the starting point and the finish point. I also provide the written script for each lesson. There's a quiz at the end, to ensure that you’ve mastered the topics. I make it easy for you to succeed. Let's get started!

Data analysis in Excel for Microsoft 365 has become simpler than ever. We have NEW Excel functions like XLOOKUP, FILTER, SORT, UNIQUE, SEQUENCE and MORE! PLUS: Microsoft has changed Excel’s calculation engine. This change impacts EVERYONE who uses Microsoft 365 version: Beginner to Advanced Excel users. There are MULTIPLE ways you can apply Dynamic Arrays and the NEW Excel Functions to YOUR Files. This course shows you how to MAXIMIZE the NEW Potential in Excel 365! For example: Use Excel's new FILTER Function to find multiple match results Use Excel's new XLOOKUP function for complex lookups (no more VLOOKUP or Index Match) Create Excel Dashboard reports in MINUTES instead of HOURS Create Pivot Table style reports, without using Pivot Tables - no need to press "refresh" this way Quickly create dynamic loan amortization reports in Excel or dynamic calendars Master the new UNIQUE, SORT & SORTBY Excel Functions Use the brand new Excel RANDARRAY Function to randomly sort lists Use VLOOKUP, IF and SUMIFS together with Excel Dynamic Arrays formulas In addition you'll learn: How to add Interactivity to your Excel reports as never done before How to use the new Dynamic Arrays formulas in your files How Excel's calculation engine has changed and how this impacts all existing formulas Compatibility & how older files behave in the new Excel and New Excel files in the old Excel Do Dynamic Arrays make our spreadsheets faster or slower? Use Dynamic Array referencing as Excel chart ranges Solve difficult problems - such as split text and numbers from alphanumeric values & much more... Most importantly - how to think outside the box to solve any challenges you come across But First: *** HOW TO CHECK IF YOUR EXCEL VERSION HAS DYNAMIC ARRAYS *** Do you have Excel for Microsoft 365? Then you already have dynamic arrays and the new Excel functions. Check out the free preview video called "Do you have Dynamic Arrays?" and do the test outline in the video. If you don't have dynamic arrays BUT you have Excel for Microsoft 365 run the latest update to install the new features. But please note: Excel dynamic arrays will NOT be a part of Excel 2010, Excel 2013, Excel 2016 or EVEN Excel 2019. Only in Excel 365 or Excel on the web. *** WHY TAKE THIS SPECIFIC EXCEL COURSE? *** Excel Dynamic Arrays are brand-new. Complex tasks will now be done with SIMPLE Excel formulas . Everything you wished Excel could do, can now be done! In this course you'll solve dozens of practical real-world examples. They'll help you think outside the box so you can work smarter not harder. In the course you will get: ⯆ Excel Practice & Solutions Workbooks for each section ⯆ Course notes outlining the MOST IMPORTANT Concepts ⯆ Quiz questions to test your understanding ***  WHY WOULD YOU CHOOSE TO LEARN EXCEL?  *** Excel can do so much for your career. It's just one program but it's the one hiring managers are interested in. That’s why basic Excel skills is a mandatory requirement for most office-based professionals today. Superior Microsoft Excel skills can get you a promotion. Some jobs require that to begin with. *** WHICH VERSION OF EXCEL IS USED IN THE COURSE? *** The course is applicable ONLY for Excel for Microsoft 365 (Also available for Excel on the Web). Dynamic Arrays will NOT be part of Excel 2019 perpetual license. *** Feedback from our students *** ★★★★★ "I highly recommend this well-organized course for anyone whose work/projects involve data analysis. The knowledge I've gained on the new dynamic array functions will raise the level of my analysis while making my work easier at the same time. The new functions are well explained with business examples, and the course notes will be a great reference!" Jennifer ★★★★★ “This course is magical. I am sure everyone using Excel will have to upgrade their knowledge soon. Thanks for the enlightening journey.” Dheeraj ★★★★★ “Very well organized and implemented course. It was easy to follow along yet challenging enough to learn. As an example, I had never used the CHOOSE function which was your solution in one of the advanced challenges. Still wanting to try and figure out the solution on my own (without seeing yours first), I tried watching a video from another YouTube instructor on that specific function. Unfortunately, I didn't really get it until I watched your instruction. The way you break down the components of a complex formula, showing various examples of how they work, before building up to the complete solution is a great method of teaching. Your advice for spilling component results next to the source data is an excellent method for troubleshooting formula problems...if I could only get the hang of it and remember to do it!” Stephanie ★★★★★ “I give you a big 10 for the explanation of this course, I learned a lot from it.” Jos There's a 100% money back guarantee. You have nothing to lose. Check out the lectures inside and see if you can apply the techniques to your work. The course comes with lifetime access. Buy now. Watch anytime.

This Microsoft Excel Advanced Formulas and Functions training course from Infinite Skills takes you beyond the basics of Excel, and teaches you how to use the advanced formulas and functions in this spreadsheet program by Microsoft. This course is designed for users that already have a basic working knowledge of Excel. You will begin by reviewing the basic operations, such as sum and count syntax, function processing order, and knowing the troubleshooting tools. You will explore extended formula usage with 3D referencing, naming cells and absolute referencing. Guy proceeds to instruct you on how to look up and reference type functions using VLookup and HLookup. Other features that are covered in this computer based training include; generating random numbers and values, locating data using text functions, and learning to use an array formula to count unique entries. By the completion of this training course, you will be comfortable with using many of the advanced formulas and functions that this powerful spreadsheet software from Microsoft offers. Working files are included, allowing you to follow along with the author throughout the lessons.

Learn to calculate how much money you can save by making additional payments into your home loan / mortgage or other loan. In this course we'll learn how to use the Financial Loan formulas in Excel to calculate how much money you can save when making additional payments into your loan.  We'll also learn to calculate the exact period at which you can pay your loan off.  This will really assist you to set achievable goals regarding your outstanding mortgage bond. This course will take you through a step-by-step guide to create a spreadsheet which details the payment for each period of a loan over the lifetime of the loan.  In the example we look at a mortgage bond of 1,500,000 which is paid monthly over 20 years. The course is created using Excel 2016 and although prior versions of Excel have all the same functionality, the screen may look different so if you are not comfortable using Excel you could get confused.  You really should have some basic knowledge of Excel already and you should be able to use formulas and understand how to link cells into formulas. The topics we cover in the course are: The Excel PMT function to calculate the monthly payment The Excel IPMT function to calculate the interest portion of each months payment The Excel PPMT function to calculate the principal (capital) portion of each months payment The Excel IF function for logical conditions It is very encouraging to calculate how much you can save on your bond with even small additional amounts! You can easily find templates or similar calculations but this course will truly help you understand how a loan works.

In this course you will learn how to use a number of formulas that will help you get your work done with less effort, as well as how to leverage the benefits of Excel tables.  You will also learn about using conditional formatting. This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5. Recent reviews: "This training was very helpful in upgrading knowledge in Excel with the help of practical exercises. I would definitely recommend this course." "Excellent, efficient and informative course. The exercises after each set of videos was particularly useful." "I found the course very informative. I am pretty good with excel but I learned quite a few tips and tricks that I can implement." In this course you will learn how to use a number of formulas that will help you get your work done with less effort, as well as how to leverage the benefits of Excel tables.  You will also learn about using conditional formatting. This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5. **** Life time access to course materials and practice activities. **** Welcome to this course on Tables, Conditional Formatting and Excel formulas.  This course is for all Excel users who want to take their Excel skills and capabilities to the next level. This course will increase your productivity as you use tables, conditional formatting and formulas with ease in your Excel spreadsheets.  The course is presented in an easy to follow step by step approach.  The course also includes practical activities for you to practice the skills that you have been learnt on the course. The course will provide you with a comprehensive understanding of the following: Tables How to create and format Tables How to easily filter data in text, numeric and date fields Easily Sum, Average, Count and use Max and Min in your tables Use Slicers to easily filter Table data Conditional Formatting How to apply conditional formatting rules How to easily highlight the Top 10 Learn to use Data Bars and Color Scales Learn to apply icons Formulas Learn SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF and COUNTIFS Learn a range of Date formula such as Year, Month, WeekDay, NetWorkDays amd WorkDay Learn Text formulas such as LEFT, MID, RIGHT and TRIM Learn to use the IF formula to create powerful 'IF Then' logic Learn the HLOOKUP and VLOOKUP This course is presented in Excel 2013. A minimum of Excel 2007 is required to be able to work with the Tables, Conditional Formatting and some of the formula functions.

WHAT’S YOUR STORY? Are you a business professional needing to up-skill? Are you struggling to get a pay-rise and/or promotion? Are you a recent graduate with an empty looking resume and no job experience? Have you recently been laid off, fired or had a contract end? If you answered 'yes' to any of the above then having “Expert Microsoft Office Skills” will get you closer to your goal of either landing your first job, a new job or progressing further in your current role. Here's why. The job market has never been more volatile. Statistically, people are changing jobs more often now than they ever have before and that also means people are also losing jobs to newcomers who are far more skilled. So if you’re not up-skilling, you’re falling behind. It’s scary I know. I’ve experienced this myself. A study released by Microsoft and the IDC showed that among 14.6 million job postings, proficiency in Microsoft Office was ranked 2nd as the most desired skills by employers leading up to 2020. Microsoft Office proficiency ranked higher than Project Management skills, Sales Experience, Time Management, Analytical Skills, Interpersonal Skills and Work Ethics. This is because we live in the digital age, meaning employers are looking for proficient data handlers who process data faster, are more data-organised and can communicate effectively via digital channels. These are skills everyone should have no matter the discipline because they are transferable skills. It makes you more adaptable and more valuable in the long-term. This brings us back to Microsoft Office. It is the oldest, most well-known, most affordable and most trusted data management tool available and hence everyone uses it. So to be noticed and taken seriously in your job or job application, proficiency in these programs is compulsory. ONLINE TRAINING AND THE MOST COMMON PROBLEMS One of the most common problems with online learning content is that there is so much of it now and it’s difficult to know where to start or who to turn to. Many go the YouTube route and piece together videos from hundreds of tutorials from hundreds of tutors hoping to become an expert at the end of it all. This simply won’t happen and will just waste your time. Many take the route you’re about to take, they decide to enroll in an online training course. Many charge hundreds, sometimes thousands of dollars for their courses which is simply unaffordable for university students, recent graduates, the unemployed or those looking for a career change. That is the reason why I have decided to keep this course as low as possible even though I’m offering substantially more content than most of my competitors here on Udemy. COURSE DELIVERY STYLE I have been using Microsoft Office for over 20 years. I know the in’s and out’s and the simplest ways of doing things. My delivery philosophy is simple, if I can’t get a 6 year old to follow along and understand, than I’m not teaching correctly. I hate complicated language and so do you. Nobody likes trainers who focus on impressing rather than teaching and giving value to students. That is also why my lecture videos are as short as can be and divided into small sections for easy consumption. So you won’t get unnecessary chit chat or nonsense. I also assume that all my students are near-sighted and as such, I use a special software tool that allows me to draw on the screen to show exactly what I’m about to press as well as zoom in on small area’s so you don’t miss a thing. WHAT YOU’LL LEARN IN THIS COURSE The proper use and understanding of formula's in Microsoft Excel is essential in mastering the full program. It is a foundation skill that should not be ignored! I'll teach you from the ground up how to construct and perform manual calculations, nested formula's, logic based functions, cell linkages, autosum functions and text/number concatenation. Along with these functions I'll also cover additional techniques such as decimal place setting and formula expansion. ABOUT ME Member of the Udemy Council Co-Founded Paperclip Learning which teaches Microsoft Office Over 60,000 students Over 130,000 enrollments Over 5,000 Positive Reviews Over 20 courses on Udemy Teaching is my passion and my creative outlet. I have been using the Microsoft Office package since I was a child and have been using it consistently throughout my life. My teaching experiences span from teaching primary school students, high school students, university graduates and business professionals. Professionally, I am trained in Aerospace Engineering, Database Design and Business Analytics. TESTIMONIALS Yu Hui Jun Yu - The courses are simply amazing and I can learn them rapidly. The hints presented were also very useful. I like the 'mini-lesson' format. Fast and efficient. The instructor's direction is very detailed and easy to understand. I can immediately start using this program. Thanks! Narayanan Krishnamoorthy - Perfect and to the point...the instructor doesn’t waste time and gets to the point quickly!! Lala Darchinova - I've been looking for this kind of course for ages! And finally I find it. Short, comprehensive and absolutely interesting! Thank you for the work you are doing. Spencer Berkman - Extremely knowledgeable and clear on instructions. E Frank - Simple to learn techniques and instructor made it all really easy. Thank you! Parth Gandhi - I learned techniques in a very short time...no need to google and waste time finding the perfect approach

Master Excel Formulas, Tips & Tricks. Learn to use Excel's Amazingly Powerful Formulas and the Tips and Tricks I've picked up over the past 20 years using Excel. It doesn't take that much effort to go from someone barely proficient in utilizing Excel to become the Superstar at your organization. Being the Excel Guru has afforded me a lot of opportunities where I may not otherwise have the chance to participate. We'll look at formulas, tips & tricks that I use almost every day while working. I don't want this training to end there. I'd like as much participation on your part as possible, letting me know exactly what problems you are having a tough time solving. This way I can learn what issues you are having and cater the training to meet YOUR needs! So what you are waiting for? Sign up right now and let's get started. See you inside!